IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[catalog]') AND TYPE in (N'U'))
BEGIN
CREATE Table catalog
(
    catalog_id INT NOT NULL,
    name NVARCHAR(100) NULL,
    description NVARCHAR(Max) NULL,
    create_date DATETIME DEFAULT(GETDATE()),
    update_date DATETIME,
	CONSTRAINT PK_catalog_id PRIMARY KEY CLUSTERED (catalog_id)
) 
END
GO

IF NOT EXISTS(SELECT 1 FROM syscolumns WHERE [Name]='small_order_description' AND Id=(SELECT Id FROM sysobjects WHERE [Name]='catalog'))
    ALTER TABLE catalog ADD small_order_description VARCHAR(2000) NULL
GO

IF NOT EXISTS(SELECT 1 FROM syscolumns WHERE [Name]='bulk_order_description' AND Id=(SELECT Id FROM sysobjects WHERE [Name]='catalog'))
    ALTER TABLE catalog ADD bulk_order_description VARCHAR(2000) NULL
GO
